package cn.edu.dlut.port.isp.repostitory;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import cn.edu.dlut.port.isp.bean.M_thp_dlp;


// This will be AUTO IMPLEMENTED by Spring into a Bean called userRepository
// CRUD refers Create, Read, Update, Delete

public interface M_thp_dlpRepository extends CrudRepository<M_thp_dlp, Long> {
	
	@Query("select bean from M_thp_dlp bean where floor(bean.date/100)=?1")
	List<M_thp_dlp> findThpByYear(Integer year);
}
